library(tidyverse)
library(ggplot2)
knitr::opts_chunk$set(echo = TRUE, warning=FALSE, message=FALSE)Challenge 8 Instructions
challenge_8
railroads
snl
faostat
debt
Joining Data
Challenge Overview
Today’s challenge is to:
- read in multiple data sets, and describe the data set using both words and any supporting information (e.g., tables, etc)
- tidy data (as needed, including sanity checks)
- mutate variables as needed (including sanity checks)
- join two or more data sets and analyze some aspect of the joined data
Read in data
- snl ⭐⭐⭐⭐⭐
library(readr)
snlactors <- read.csv(file = "_data/snl_actors.csv",
header=TRUE,
sep = ","
)
snlcasts <- read.csv(file = "_data/snl_casts.csv",
header=TRUE,
sep = ","
)
snlseasons <- read.csv(file = "_data/snl_seasons.csv",
header=TRUE,
sep = ","
)Briefly describe the data
The dimensions of the snl actor data are 2306 rows and four columns. Each row represents an actor and with detailed informaiton, column 1 is the actor’s name, column 2 is a url associated with the actor, column 3 states whether they are a cast member or a guest, and column 4 is the gender. The variables are all character/categorical data.
The dimensions of the snl cast data are 614 rows and 8 columns. This data set includes cast members, but not guests for 46 seasons from 1975-2020, the cast members’ first and last episode dates, if they were an Update Anchor, the number of episodes for each season and proportion of the episodes that the cast member was in.
The dimensions of the snl seasons data is 46 rows and 5 columns. This data set includes cast members, but not guests for 46 seasons from 1975-2020. This data set includes the season id (1-46), the year, dates of the first and last episodes, and the number of shows in each season.
dim(snlactors)[1] 2306 4head(snlactors) aid url type gender
1 Kate McKinnon /Cast/?KaMc cast female
2 Alex Moffat /Cast/?AlMo cast male
3 Ego Nwodim /Cast/?EgNw cast unknown
4 Chris Redd /Cast/?ChRe cast male
5 Kenan Thompson /Cast/?KeTh cast male
6 Carey Mulligan /Guests/?3677 guest andydim(snlcasts)[1] 614 8head(snlcasts) aid sid featured first_epid last_epid update_anchor n_episodes
1 A. Whitney Brown 11 True 19860222 NA False 8
2 A. Whitney Brown 12 True NA NA False 20
3 A. Whitney Brown 13 True NA NA False 13
4 A. Whitney Brown 14 True NA NA False 20
5 A. Whitney Brown 15 True NA NA False 20
6 A. Whitney Brown 16 True NA NA False 20
season_fraction
1 0.4444444
2 1.0000000
3 1.0000000
4 1.0000000
5 1.0000000
6 1.0000000dim(snlseasons)[1] 46 5head(snlseasons) sid year first_epid last_epid n_episodes
1 1 1975 19751011 19760731 24
2 2 1976 19760918 19770521 22
3 3 1977 19770924 19780520 20
4 4 1978 19781007 19790526 20
5 5 1979 19791013 19800524 20
6 6 1980 19801115 19810411 13Join Data
The snlactors and snlcasts data sets were joined with the Actor ID (aid) being the key variable. I tried the merge and innerjoin functions to combine the tables and then did a count of the gender and a bar graph of the gender. The bar graph of the gender also shows which actors were featured which can mean a newer cast member.
#Using merge and counting the gender of the actors
snl_gendercount <- merge(x=snlactors, y=snlcasts,
by = "aid")%>%
count(gender)
snl_gendercount gender n
1 female 194
2 male 416
3 unknown 4#Using innerjoin and creating bar graph.
dfjoin <- snlactors %>%
inner_join(snlcasts, by = "aid")
dfjoin aid url type gender sid featured first_epid
1 Kate McKinnon /Cast/?KaMc cast female 37 True 20120407
2 Kate McKinnon /Cast/?KaMc cast female 38 True NA
3 Kate McKinnon /Cast/?KaMc cast female 39 False NA
4 Kate McKinnon /Cast/?KaMc cast female 40 False NA
5 Kate McKinnon /Cast/?KaMc cast female 41 False NA
6 Kate McKinnon /Cast/?KaMc cast female 42 False NA
7 Kate McKinnon /Cast/?KaMc cast female 43 False NA
8 Kate McKinnon /Cast/?KaMc cast female 44 False NA
9 Kate McKinnon /Cast/?KaMc cast female 45 False NA
10 Kate McKinnon /Cast/?KaMc cast female 46 False NA
11 Alex Moffat /Cast/?AlMo cast male 42 True NA
12 Alex Moffat /Cast/?AlMo cast male 43 True NA
13 Alex Moffat /Cast/?AlMo cast male 44 False NA
14 Alex Moffat /Cast/?AlMo cast male 45 False NA
15 Alex Moffat /Cast/?AlMo cast male 46 False NA
16 Ego Nwodim /Cast/?EgNw cast unknown 44 True NA
17 Ego Nwodim /Cast/?EgNw cast unknown 45 True NA
18 Ego Nwodim /Cast/?EgNw cast unknown 46 False NA
19 Chris Redd /Cast/?ChRe cast male 43 True NA
20 Chris Redd /Cast/?ChRe cast male 44 True NA
21 Chris Redd /Cast/?ChRe cast male 45 False NA
22 Chris Redd /Cast/?ChRe cast male 46 False NA
23 Kenan Thompson /Cast/?KeTh cast male 29 True NA
24 Kenan Thompson /Cast/?KeTh cast male 30 True NA
25 Kenan Thompson /Cast/?KeTh cast male 31 False NA
26 Kenan Thompson /Cast/?KeTh cast male 32 False NA
27 Kenan Thompson /Cast/?KeTh cast male 33 False NA
28 Kenan Thompson /Cast/?KeTh cast male 34 False NA
29 Kenan Thompson /Cast/?KeTh cast male 35 False NA
30 Kenan Thompson /Cast/?KeTh cast male 36 False NA
31 Kenan Thompson /Cast/?KeTh cast male 37 False NA
32 Kenan Thompson /Cast/?KeTh cast male 38 False NA
33 Kenan Thompson /Cast/?KeTh cast male 39 False NA
34 Kenan Thompson /Cast/?KeTh cast male 40 False NA
35 Kenan Thompson /Cast/?KeTh cast male 41 False NA
36 Kenan Thompson /Cast/?KeTh cast male 42 False NA
37 Kenan Thompson /Cast/?KeTh cast male 43 False NA
38 Kenan Thompson /Cast/?KeTh cast male 44 False NA
39 Kenan Thompson /Cast/?KeTh cast male 45 False NA
40 Kenan Thompson /Cast/?KeTh cast male 46 False NA
41 Aidy Bryant /Cast/?AiBr cast female 38 True NA
42 Aidy Bryant /Cast/?AiBr cast female 39 False NA
43 Aidy Bryant /Cast/?AiBr cast female 40 False NA
44 Aidy Bryant /Cast/?AiBr cast female 41 False NA
45 Aidy Bryant /Cast/?AiBr cast female 42 False NA
46 Aidy Bryant /Cast/?AiBr cast female 43 False NA
47 Aidy Bryant /Cast/?AiBr cast female 44 False NA
48 Aidy Bryant /Cast/?AiBr cast female 45 False NA
49 Aidy Bryant /Cast/?AiBr cast female 46 False NA
50 Mikey Day /Cast/?MiDa cast male 42 True NA
51 Mikey Day /Cast/?MiDa cast male 43 True NA
52 Mikey Day /Cast/?MiDa cast male 44 False NA
53 Mikey Day /Cast/?MiDa cast male 45 False NA
54 Mikey Day /Cast/?MiDa cast male 46 False NA
55 Heidi Gardner /Cast/?HeGa cast female 43 True NA
56 Heidi Gardner /Cast/?HeGa cast female 44 True NA
57 Heidi Gardner /Cast/?HeGa cast female 45 False NA
58 Heidi Gardner /Cast/?HeGa cast female 46 False NA
59 Lauren Holt /Cast/?LaHo cast female 46 True NA
60 Pete Davidson /Cast/?PeDa cast male 40 True NA
61 Pete Davidson /Cast/?PeDa cast male 41 True NA
62 Pete Davidson /Cast/?PeDa cast male 42 False NA
63 Pete Davidson /Cast/?PeDa cast male 43 False NA
64 Pete Davidson /Cast/?PeDa cast male 44 False NA
65 Pete Davidson /Cast/?PeDa cast male 45 False NA
66 Pete Davidson /Cast/?PeDa cast male 46 False NA
67 Chloe Fineman /Cast/?ChFi cast female 45 True NA
68 Chloe Fineman /Cast/?ChFi cast female 46 True NA
69 Darrell Hammond /Cast/?DaHa cast male 21 False NA
70 Darrell Hammond /Cast/?DaHa cast male 22 False NA
71 Darrell Hammond /Cast/?DaHa cast male 23 False NA
72 Darrell Hammond /Cast/?DaHa cast male 24 False NA
73 Darrell Hammond /Cast/?DaHa cast male 25 False NA
74 Darrell Hammond /Cast/?DaHa cast male 26 False NA
75 Darrell Hammond /Cast/?DaHa cast male 27 False NA
76 Darrell Hammond /Cast/?DaHa cast male 28 False NA
77 Darrell Hammond /Cast/?DaHa cast male 29 False NA
78 Darrell Hammond /Cast/?DaHa cast male 30 False NA
79 Darrell Hammond /Cast/?DaHa cast male 31 False NA
80 Darrell Hammond /Cast/?DaHa cast male 32 False NA
81 Darrell Hammond /Cast/?DaHa cast male 33 False NA
82 Darrell Hammond /Cast/?DaHa cast male 34 False NA
83 Colin Jost /Cast/?CoJo cast male 39 True 20140301
84 Colin Jost /Cast/?CoJo cast male 40 True NA
85 Colin Jost /Cast/?CoJo cast male 41 False NA
86 Colin Jost /Cast/?CoJo cast male 42 False NA
87 Colin Jost /Cast/?CoJo cast male 43 False NA
88 Colin Jost /Cast/?CoJo cast male 44 False NA
89 Colin Jost /Cast/?CoJo cast male 45 False NA
90 Colin Jost /Cast/?CoJo cast male 46 False NA
91 Michael Che /Cast/?MiCh cast male 40 True NA
92 Michael Che /Cast/?MiCh cast male 41 True NA
93 Michael Che /Cast/?MiCh cast male 42 False NA
94 Michael Che /Cast/?MiCh cast male 43 False NA
95 Michael Che /Cast/?MiCh cast male 44 False NA
96 Michael Che /Cast/?MiCh cast male 45 False NA
97 Michael Che /Cast/?MiCh cast male 46 False NA
98 Beck Bennett /Cast/?BeBe cast male 39 True NA
99 Beck Bennett /Cast/?BeBe cast male 40 True NA
100 Beck Bennett /Cast/?BeBe cast male 41 False NA
101 Beck Bennett /Cast/?BeBe cast male 42 False NA
102 Beck Bennett /Cast/?BeBe cast male 43 False NA
103 Beck Bennett /Cast/?BeBe cast male 44 False NA
104 Beck Bennett /Cast/?BeBe cast male 45 False NA
105 Beck Bennett /Cast/?BeBe cast male 46 False NA
106 Punkie Johnson /Cast/?PuJo cast unknown 46 True NA
107 Bowen Yang /Cast/?BoYa cast male 45 True NA
108 Bowen Yang /Cast/?BoYa cast male 46 True NA
109 Andrew Dismukes /Cast/?AnDi cast male 46 True NA
110 Kyle Mooney /Cast/?KyMo cast male 39 True NA
111 Kyle Mooney /Cast/?KyMo cast male 40 True NA
112 Kyle Mooney /Cast/?KyMo cast male 41 False NA
113 Kyle Mooney /Cast/?KyMo cast male 42 False NA
114 Kyle Mooney /Cast/?KyMo cast male 43 False NA
115 Kyle Mooney /Cast/?KyMo cast male 44 False NA
116 Kyle Mooney /Cast/?KyMo cast male 45 False NA
117 Kyle Mooney /Cast/?KyMo cast male 46 False NA
118 Cecily Strong /Cast/?CeSt cast female 38 True NA
119 Cecily Strong /Cast/?CeSt cast female 39 False NA
120 Cecily Strong /Cast/?CeSt cast female 40 False NA
121 Cecily Strong /Cast/?CeSt cast female 41 False NA
122 Cecily Strong /Cast/?CeSt cast female 42 False NA
123 Cecily Strong /Cast/?CeSt cast female 43 False NA
124 Cecily Strong /Cast/?CeSt cast female 44 False NA
125 Cecily Strong /Cast/?CeSt cast female 45 False NA
126 Cecily Strong /Cast/?CeSt cast female 46 False NA
127 Maya Rudolph /Cast/?MaRu cast female 25 True 20000506
128 Maya Rudolph /Cast/?MaRu cast female 26 True NA
129 Maya Rudolph /Cast/?MaRu cast female 27 False NA
130 Maya Rudolph /Cast/?MaRu cast female 28 False NA
131 Maya Rudolph /Cast/?MaRu cast female 29 False NA
132 Maya Rudolph /Cast/?MaRu cast female 30 False NA
133 Maya Rudolph /Cast/?MaRu cast female 31 False NA
134 Maya Rudolph /Cast/?MaRu cast female 32 False NA
135 Maya Rudolph /Cast/?MaRu cast female 33 False NA
136 Melissa Villasenor /Cast/?MeVi cast female 42 True NA
137 Melissa Villasenor /Cast/?MeVi cast female 43 True NA
138 Melissa Villasenor /Cast/?MeVi cast female 44 False NA
139 Melissa Villasenor /Cast/?MeVi cast female 45 False NA
140 Melissa Villasenor /Cast/?MeVi cast female 46 False NA
141 Martin Short /Cast/?MaSh cast male 10 False NA
142 Rachel Dratch /Cast/?RaDr cast female 25 True 19991023
143 Rachel Dratch /Cast/?RaDr cast female 26 True NA
144 Rachel Dratch /Cast/?RaDr cast female 27 False NA
145 Rachel Dratch /Cast/?RaDr cast female 28 False NA
146 Rachel Dratch /Cast/?RaDr cast female 29 False NA
147 Rachel Dratch /Cast/?RaDr cast female 30 False NA
148 Rachel Dratch /Cast/?RaDr cast female 31 False NA
149 Tina Fey /Cast/?TiFe cast female 26 True NA
150 Tina Fey /Cast/?TiFe cast female 27 False NA
151 Tina Fey /Cast/?TiFe cast female 28 False NA
152 Tina Fey /Cast/?TiFe cast female 29 False NA
153 Tina Fey /Cast/?TiFe cast female 30 False NA
154 Tina Fey /Cast/?TiFe cast female 31 False NA
155 Kristen Wiig /Cast/?KrWi cast female 31 True 20051112
156 Kristen Wiig /Cast/?KrWi cast female 32 False NA
157 Kristen Wiig /Cast/?KrWi cast female 33 False NA
158 Kristen Wiig /Cast/?KrWi cast female 34 False NA
159 Kristen Wiig /Cast/?KrWi cast female 35 False NA
160 Kristen Wiig /Cast/?KrWi cast female 36 False NA
161 Kristen Wiig /Cast/?KrWi cast female 37 False NA
162 Jimmy Fallon /Cast/?JiFa cast male 24 True NA
163 Jimmy Fallon /Cast/?JiFa cast male 25 False NA
164 Jimmy Fallon /Cast/?JiFa cast male 26 False NA
165 Jimmy Fallon /Cast/?JiFa cast male 27 False NA
166 Jimmy Fallon /Cast/?JiFa cast male 28 False NA
167 Jimmy Fallon /Cast/?JiFa cast male 29 False NA
168 Chris Rock /Cast/?ChRo cast male 16 True NA
169 Chris Rock /Cast/?ChRo cast male 17 False NA
170 Chris Rock /Cast/?ChRo cast male 18 False NA
171 Fred Armisen /Cast/?FrAr cast male 28 True NA
172 Fred Armisen /Cast/?FrAr cast male 29 True NA
173 Fred Armisen /Cast/?FrAr cast male 30 False NA
174 Fred Armisen /Cast/?FrAr cast male 31 False NA
175 Fred Armisen /Cast/?FrAr cast male 32 False NA
176 Fred Armisen /Cast/?FrAr cast male 33 False NA
177 Fred Armisen /Cast/?FrAr cast male 34 False NA
178 Fred Armisen /Cast/?FrAr cast male 35 False NA
179 Fred Armisen /Cast/?FrAr cast male 36 False NA
180 Fred Armisen /Cast/?FrAr cast male 37 False NA
181 Fred Armisen /Cast/?FrAr cast male 38 False NA
182 Jason Sudeikis /Cast/?JaSu cast male 30 True 20050507
183 Jason Sudeikis /Cast/?JaSu cast male 31 True NA
184 Jason Sudeikis /Cast/?JaSu cast male 32 False NA
185 Jason Sudeikis /Cast/?JaSu cast male 33 False NA
186 Jason Sudeikis /Cast/?JaSu cast male 34 False NA
187 Jason Sudeikis /Cast/?JaSu cast male 35 False NA
188 Jason Sudeikis /Cast/?JaSu cast male 36 False NA
189 Jason Sudeikis /Cast/?JaSu cast male 37 False NA
190 Jason Sudeikis /Cast/?JaSu cast male 38 False NA
191 Adam Sandler /Cast/?AdSa cast male 16 True 19910209
192 Adam Sandler /Cast/?AdSa cast male 17 True NA
193 Adam Sandler /Cast/?AdSa cast male 18 True NA
194 Adam Sandler /Cast/?AdSa cast male 19 False NA
195 Adam Sandler /Cast/?AdSa cast male 20 False NA
196 Rob Schneider /Cast/?RoSc cast male 16 True 19901027
197 Rob Schneider /Cast/?RoSc cast male 17 True NA
198 Rob Schneider /Cast/?RoSc cast male 18 False NA
199 Rob Schneider /Cast/?RoSc cast male 19 False NA
200 Amy Poehler /Cast/?AmPo cast female 27 True NA
201 Amy Poehler /Cast/?AmPo cast female 28 False NA
202 Amy Poehler /Cast/?AmPo cast female 29 False NA
203 Amy Poehler /Cast/?AmPo cast female 30 False NA
204 Amy Poehler /Cast/?AmPo cast female 31 False NA
205 Amy Poehler /Cast/?AmPo cast female 32 False NA
206 Amy Poehler /Cast/?AmPo cast female 33 False NA
207 Amy Poehler /Cast/?AmPo cast female 34 False NA
208 Ana Gasteyer /Cast/?AnGa cast female 22 False NA
209 Ana Gasteyer /Cast/?AnGa cast female 23 False NA
210 Ana Gasteyer /Cast/?AnGa cast female 24 False NA
211 Ana Gasteyer /Cast/?AnGa cast female 25 False NA
212 Ana Gasteyer /Cast/?AnGa cast female 26 False NA
213 Ana Gasteyer /Cast/?AnGa cast female 27 False NA
214 Bill Hader /Cast/?BiHa cast male 31 True NA
215 Bill Hader /Cast/?BiHa cast male 32 False NA
216 Bill Hader /Cast/?BiHa cast male 33 False NA
217 Bill Hader /Cast/?BiHa cast male 34 False NA
218 Bill Hader /Cast/?BiHa cast male 35 False NA
219 Bill Hader /Cast/?BiHa cast male 36 False NA
220 Bill Hader /Cast/?BiHa cast male 37 False NA
221 Bill Hader /Cast/?BiHa cast male 38 False NA
222 Molly Shannon /Cast/?MoSh cast female 20 True 19950225
223 Molly Shannon /Cast/?MoSh cast female 21 False NA
224 Molly Shannon /Cast/?MoSh cast female 22 False NA
225 Molly Shannon /Cast/?MoSh cast female 23 False NA
226 Molly Shannon /Cast/?MoSh cast female 24 False NA
227 Molly Shannon /Cast/?MoSh cast female 25 False NA
228 Molly Shannon /Cast/?MoSh cast female 26 False NA
229 Jon Lovitz /Cast/?JoLo cast male 11 False NA
230 Jon Lovitz /Cast/?JoLo cast male 12 False NA
231 Jon Lovitz /Cast/?JoLo cast male 13 False NA
232 Jon Lovitz /Cast/?JoLo cast male 14 False NA
233 Jon Lovitz /Cast/?JoLo cast male 15 False NA
234 Eddie Murphy /Cast/?EdMu cast male 6 False 19801213
235 Eddie Murphy /Cast/?EdMu cast male 7 False NA
236 Eddie Murphy /Cast/?EdMu cast male 8 False NA
237 Eddie Murphy /Cast/?EdMu cast male 9 False NA
238 Tracy Morgan /Cast/?TrMo cast male 22 False NA
239 Tracy Morgan /Cast/?TrMo cast male 23 False NA
240 Tracy Morgan /Cast/?TrMo cast male 24 False NA
241 Tracy Morgan /Cast/?TrMo cast male 25 False NA
242 Tracy Morgan /Cast/?TrMo cast male 26 False NA
243 Tracy Morgan /Cast/?TrMo cast male 27 False NA
244 Tracy Morgan /Cast/?TrMo cast male 28 False NA
245 Will Ferrell /Cast/?WiFe cast male 21 False NA
246 Will Ferrell /Cast/?WiFe cast male 22 False NA
247 Will Ferrell /Cast/?WiFe cast male 23 False NA
248 Will Ferrell /Cast/?WiFe cast male 24 False NA
249 Will Ferrell /Cast/?WiFe cast male 25 False NA
250 Will Ferrell /Cast/?WiFe cast male 26 False NA
251 Will Ferrell /Cast/?WiFe cast male 27 False NA
252 Leslie Jones /Cast/?LeJo cast female 40 True 20141025
253 Leslie Jones /Cast/?LeJo cast female 41 True NA
254 Leslie Jones /Cast/?LeJo cast female 42 False NA
255 Leslie Jones /Cast/?LeJo cast female 43 False NA
256 Leslie Jones /Cast/?LeJo cast female 44 False NA
257 Ben Stiller /Cast/?BeSt cast male 14 True 19890325
258 Nancy Walls /Cast/?NaWa cast female 21 False NA
259 Seth Meyers /Cast/?SeMe cast male 27 True NA
260 Seth Meyers /Cast/?SeMe cast male 28 True NA
261 Seth Meyers /Cast/?SeMe cast male 29 False NA
262 Seth Meyers /Cast/?SeMe cast male 30 False NA
263 Seth Meyers /Cast/?SeMe cast male 31 False NA
264 Seth Meyers /Cast/?SeMe cast male 32 False NA
265 Seth Meyers /Cast/?SeMe cast male 33 False NA
266 Seth Meyers /Cast/?SeMe cast male 34 False NA
267 Seth Meyers /Cast/?SeMe cast male 35 False NA
268 Seth Meyers /Cast/?SeMe cast male 36 False NA
269 Seth Meyers /Cast/?SeMe cast male 37 False NA
270 Seth Meyers /Cast/?SeMe cast male 38 False NA
271 Seth Meyers /Cast/?SeMe cast male 39 False NA
272 Luke Null /Cast/?LuNu cast male 43 True NA
273 Nasim Pedrad /Cast/?NaPe cast female 35 True NA
274 Nasim Pedrad /Cast/?NaPe cast female 36 True NA
275 Nasim Pedrad /Cast/?NaPe cast female 37 False NA
276 Nasim Pedrad /Cast/?NaPe cast female 38 False NA
277 Nasim Pedrad /Cast/?NaPe cast female 39 False NA
278 Vanessa Bayer /Cast/?VaBa cast female 36 True NA
279 Vanessa Bayer /Cast/?VaBa cast female 37 True NA
280 Vanessa Bayer /Cast/?VaBa cast female 38 False NA
281 Vanessa Bayer /Cast/?VaBa cast female 39 False NA
282 Vanessa Bayer /Cast/?VaBa cast female 40 False NA
283 Vanessa Bayer /Cast/?VaBa cast female 41 False NA
284 Vanessa Bayer /Cast/?VaBa cast female 42 False NA
285 Andy Samberg /Cast/?AnSa cast male 31 True NA
286 Andy Samberg /Cast/?AnSa cast male 32 False NA
287 Andy Samberg /Cast/?AnSa cast male 33 False NA
288 Andy Samberg /Cast/?AnSa cast male 34 False NA
289 Andy Samberg /Cast/?AnSa cast male 35 False NA
290 Andy Samberg /Cast/?AnSa cast male 36 False NA
291 Andy Samberg /Cast/?AnSa cast male 37 False NA
292 Bill Murray /Cast/?BiMu cast male 2 False 19770115
293 Bill Murray /Cast/?BiMu cast male 3 False NA
294 Bill Murray /Cast/?BiMu cast male 4 False NA
295 Bill Murray /Cast/?BiMu cast male 5 False NA
296 Sasheer Zamata /Cast/?SaZa cast female 39 True 20140118
297 Sasheer Zamata /Cast/?SaZa cast female 40 True NA
298 Sasheer Zamata /Cast/?SaZa cast female 41 False NA
299 Sasheer Zamata /Cast/?SaZa cast female 42 False NA
300 Bobby Moynihan /Cast/?BoMo cast male 34 True NA
301 Bobby Moynihan /Cast/?BoMo cast male 35 True NA
302 Bobby Moynihan /Cast/?BoMo cast male 36 False NA
303 Bobby Moynihan /Cast/?BoMo cast male 37 False NA
304 Bobby Moynihan /Cast/?BoMo cast male 38 False NA
305 Bobby Moynihan /Cast/?BoMo cast male 39 False NA
306 Bobby Moynihan /Cast/?BoMo cast male 40 False NA
307 Bobby Moynihan /Cast/?BoMo cast male 41 False NA
308 Bobby Moynihan /Cast/?BoMo cast male 42 False NA
309 Will Forte /Cast/?WiFo cast male 28 True NA
310 Will Forte /Cast/?WiFo cast male 29 False NA
311 Will Forte /Cast/?WiFo cast male 30 False NA
312 Will Forte /Cast/?WiFo cast male 31 False NA
313 Will Forte /Cast/?WiFo cast male 32 False NA
314 Will Forte /Cast/?WiFo cast male 33 False NA
315 Will Forte /Cast/?WiFo cast male 34 False NA
316 Will Forte /Cast/?WiFo cast male 35 False NA
317 Dana Carvey /Cast/?DaCa cast male 12 False NA
318 Dana Carvey /Cast/?DaCa cast male 13 False NA
319 Dana Carvey /Cast/?DaCa cast male 14 False NA
320 Dana Carvey /Cast/?DaCa cast male 15 False NA
321 Dana Carvey /Cast/?DaCa cast male 16 False NA
322 Dana Carvey /Cast/?DaCa cast male 17 False NA
323 Dana Carvey /Cast/?DaCa cast male 18 False NA
324 Taran Killam /Cast/?TaKi cast male 36 True NA
325 Taran Killam /Cast/?TaKi cast male 37 True NA
326 Taran Killam /Cast/?TaKi cast male 38 False NA
327 Taran Killam /Cast/?TaKi cast male 39 False NA
328 Taran Killam /Cast/?TaKi cast male 40 False NA
329 Taran Killam /Cast/?TaKi cast male 41 False NA
330 Jay Pharoah /Cast/?JaPh cast male 36 True NA
331 Jay Pharoah /Cast/?JaPh cast male 37 True NA
332 Jay Pharoah /Cast/?JaPh cast male 38 False NA
333 Jay Pharoah /Cast/?JaPh cast male 39 False NA
334 Jay Pharoah /Cast/?JaPh cast male 40 False NA
335 Jay Pharoah /Cast/?JaPh cast male 41 False NA
336 Jon Rudnitsky /Cast/?JoRu cast male 41 True NA
337 Phil Hartman /Cast/?PhHa cast male 12 False NA
338 Phil Hartman /Cast/?PhHa cast male 13 False NA
339 Phil Hartman /Cast/?PhHa cast male 14 False NA
340 Phil Hartman /Cast/?PhHa cast male 15 False NA
341 Phil Hartman /Cast/?PhHa cast male 16 False NA
342 Phil Hartman /Cast/?PhHa cast male 17 False NA
343 Phil Hartman /Cast/?PhHa cast male 18 False NA
344 Phil Hartman /Cast/?PhHa cast male 19 False NA
345 Julia Louis-Dreyfus /Cast/?JuLD cast female 8 False NA
346 Julia Louis-Dreyfus /Cast/?JuLD cast female 9 False NA
347 Julia Louis-Dreyfus /Cast/?JuLD cast female 10 False NA
348 Mike O'Brien /Cast/?MPOB cast male 39 True NA
349 Mike Myers /Cast/?MiMy cast male 14 True 19890121
350 Mike Myers /Cast/?MiMy cast male 15 False NA
351 Mike Myers /Cast/?MiMy cast male 16 False NA
352 Mike Myers /Cast/?MiMy cast male 17 False NA
353 Mike Myers /Cast/?MiMy cast male 18 False NA
354 Mike Myers /Cast/?MiMy cast male 19 False NA
355 Mike Myers /Cast/?MiMy cast male 20 False NA
356 Billy Crystal /Cast/?BiCr cast male 10 False NA
357 Sarah Silverman /Cast/?SaSi cast female 19 True 19931009
358 John Milhiser /Cast/?JoMi cast male 39 True NA
359 Noel Wells /Cast/?NoWe cast female 39 True NA
360 Brooks Wheelan /Cast/?BrWh cast male 39 True NA
361 David Koechner /Cast/?DaKo cast male 21 False NA
362 Tim Robinson /Cast/?TiRo cast male 38 True NA
363 Jim Downey /Cast/?JiDo cast male 5 True 19800126
364 Chevy Chase /Cast/?ChCh cast male 1 False NA
365 Chevy Chase /Cast/?ChCh cast male 2 False NA
366 Dan Aykroyd /Cast/?DaAy cast male 1 False NA
367 Dan Aykroyd /Cast/?DaAy cast male 2 False NA
368 Dan Aykroyd /Cast/?DaAy cast male 3 False NA
369 Dan Aykroyd /Cast/?DaAy cast male 4 False NA
370 Paul Shaffer /Cast/?PaSh cast male 5 True 19791117
371 Chris Parnell /Cast/?ChPa cast male 24 True NA
372 Chris Parnell /Cast/?ChPa cast male 25 False NA
373 Chris Parnell /Cast/?ChPa cast male 26 False NA
374 Chris Parnell /Cast/?ChPa cast male 27 False 20020302
375 Chris Parnell /Cast/?ChPa cast male 28 False NA
376 Chris Parnell /Cast/?ChPa cast male 29 False NA
377 Chris Parnell /Cast/?ChPa cast male 30 False NA
378 Chris Parnell /Cast/?ChPa cast male 31 False NA
379 Abby Elliott /Cast/?AbEl cast female 34 True 20081115
380 Abby Elliott /Cast/?AbEl cast female 35 True NA
381 Abby Elliott /Cast/?AbEl cast female 36 False NA
382 Abby Elliott /Cast/?AbEl cast female 37 False NA
383 Chris Kattan /Cast/?ChKa cast male 21 True 19960316
384 Chris Kattan /Cast/?ChKa cast male 22 False NA
385 Chris Kattan /Cast/?ChKa cast male 23 False NA
386 Chris Kattan /Cast/?ChKa cast male 24 False NA
387 Chris Kattan /Cast/?ChKa cast male 25 False NA
388 Chris Kattan /Cast/?ChKa cast male 26 False NA
389 Chris Kattan /Cast/?ChKa cast male 27 False NA
390 Chris Kattan /Cast/?ChKa cast male 28 False NA
391 Paul Brittain /Cast/?PaBr cast male 36 True NA
392 Paul Brittain /Cast/?PaBr cast male 37 True NA
393 Horatio Sanz /Cast/?HrSa cast male 24 True NA
394 Horatio Sanz /Cast/?HrSa cast male 25 False NA
395 Horatio Sanz /Cast/?HrSa cast male 26 False NA
396 Horatio Sanz /Cast/?HrSa cast male 27 False NA
397 Horatio Sanz /Cast/?HrSa cast male 28 False NA
398 Horatio Sanz /Cast/?HrSa cast male 29 False NA
399 Horatio Sanz /Cast/?HrSa cast male 30 False NA
400 Horatio Sanz /Cast/?HrSa cast male 31 False NA
401 Robert Smigel /Cast/?RoSm cast male 17 True NA
402 Robert Smigel /Cast/?RoSm cast male 18 True NA
403 David Spade unknown male 16 True 19901110
404 David Spade unknown male 17 True NA
405 David Spade unknown male 18 True NA
406 David Spade unknown male 19 False NA
407 David Spade unknown male 20 False NA
408 David Spade unknown male 21 False NA
409 Jenny Slate /Cast/?JeSl cast female 35 True NA
410 Michaela Watkins /Cast/?MiWa cast female 34 True 20081115
411 Casey Wilson /Cast/?CaWi cast female 33 True 20080223
412 Casey Wilson /Cast/?CaWi cast female 34 True NA
413 Norm MacDonald /Cast/?NoMa cast male 19 True 19931002
414 Norm MacDonald /Cast/?NoMa cast male 20 False NA
415 Norm MacDonald /Cast/?NoMa cast male 21 False NA
416 Norm MacDonald /Cast/?NoMa cast male 22 False NA
417 Norm MacDonald /Cast/?NoMa cast male 23 False NA
418 Finesse Mitchell /Cast/?FiMi cast male 29 True NA
419 Finesse Mitchell /Cast/?FiMi cast male 30 True NA
420 Finesse Mitchell /Cast/?FiMi cast male 31 False NA
421 Tim Meadows /Cast/?TiMe cast male 16 True 19910209
422 Tim Meadows /Cast/?TiMe cast male 17 True NA
423 Tim Meadows /Cast/?TiMe cast male 18 True NA
424 Tim Meadows /Cast/?TiMe cast male 19 False NA
425 Tim Meadows /Cast/?TiMe cast male 20 False NA
426 Tim Meadows /Cast/?TiMe cast male 21 False NA
427 Tim Meadows /Cast/?TiMe cast male 22 False NA
428 Tim Meadows /Cast/?TiMe cast male 23 False NA
429 Tim Meadows /Cast/?TiMe cast male 24 False NA
430 Tim Meadows /Cast/?TiMe cast male 25 False NA
431 Rob Riggle /Cast/?RoRi cast male 30 True NA
432 Jeff Richards /Cast/?JeRi cast male 27 True NA
433 Jeff Richards /Cast/?JeRi cast male 28 True NA
434 Jeff Richards /Cast/?JeRi cast male 29 False NA
435 Al Franken /Cast/?AlFr cast male 3 True NA
436 Al Franken /Cast/?AlFr cast male 4 True NA
437 Al Franken /Cast/?AlFr cast male 5 True 19791215
438 Al Franken /Cast/?AlFr cast male 11 True 19860322
439 Al Franken /Cast/?AlFr cast male 14 True NA
440 Al Franken /Cast/?AlFr cast male 15 True NA
441 Al Franken /Cast/?AlFr cast male 16 True NA
442 Al Franken /Cast/?AlFr cast male 17 True NA
443 Al Franken /Cast/?AlFr cast male 18 True NA
444 Al Franken /Cast/?AlFr cast male 19 True NA
445 Al Franken /Cast/?AlFr cast male 20 True NA
446 Jim Belushi /Cast/?JiBe cast male 9 False NA
447 Jim Belushi /Cast/?JiBe cast male 10 False NA
448 Tom Davis /Cast/?ToDa cast male 3 True NA
449 Tom Davis /Cast/?ToDa cast male 4 True NA
450 Tom Davis /Cast/?ToDa cast male 5 True 19791117
451 Dean Edwards /Cast/?DeEd cast male 27 True NA
452 Dean Edwards /Cast/?DeEd cast male 28 True NA
453 Garrett Morris /Cast/?GaMo cast male 1 False NA
454 Garrett Morris /Cast/?GaMo cast male 2 False NA
455 Garrett Morris /Cast/?GaMo cast male 3 False NA
456 Garrett Morris /Cast/?GaMo cast male 4 False NA
457 Garrett Morris /Cast/?GaMo cast male 5 False NA
458 Colin Quinn /Cast/?CoQu cast male 21 True NA
459 Colin Quinn /Cast/?CoQu cast male 22 True NA
460 Colin Quinn /Cast/?CoQu cast male 23 False NA
461 Colin Quinn /Cast/?CoQu cast male 24 False NA
462 Colin Quinn /Cast/?CoQu cast male 25 False NA
463 Kevin Nealon /Cast/?KeNe cast male 12 True NA
464 Kevin Nealon /Cast/?KeNe cast male 13 False NA
465 Kevin Nealon /Cast/?KeNe cast male 14 False NA
466 Kevin Nealon /Cast/?KeNe cast male 15 False NA
467 Kevin Nealon /Cast/?KeNe cast male 16 False NA
468 Kevin Nealon /Cast/?KeNe cast male 17 False NA
469 Kevin Nealon /Cast/?KeNe cast male 18 False NA
470 Kevin Nealon /Cast/?KeNe cast male 19 False NA
471 Kevin Nealon /Cast/?KeNe cast male 20 False NA
472 Jerry Minor /Cast/?JeMi cast male 26 True NA
473 Cheri Oteri /Cast/?ChOt cast female 21 False NA
474 Cheri Oteri /Cast/?ChOt cast female 22 False NA
475 Cheri Oteri /Cast/?ChOt cast female 23 False NA
476 Cheri Oteri /Cast/?ChOt cast female 24 False NA
477 Cheri Oteri /Cast/?ChOt cast female 25 False NA
478 Jim Breuer /Cast/?JiBr cast male 21 False NA
479 Jim Breuer /Cast/?JiBr cast male 22 False NA
480 Jim Breuer /Cast/?JiBr cast male 23 False NA
481 Gilbert Gottfried unknown male 6 False NA
482 Mark McKinney /Cast/?MaMc cast male 20 False 19950114
483 Mark McKinney /Cast/?MaMc cast male 21 False NA
484 Mark McKinney /Cast/?MaMc cast male 22 False NA
485 Michael McKean /Cast/?MiMc cast male 19 False 19940312
486 Michael McKean /Cast/?MiMc cast male 20 False NA
487 Chris Farley /Cast/?ChFa cast male 16 True NA
488 Chris Farley /Cast/?ChFa cast male 17 False NA
489 Chris Farley /Cast/?ChFa cast male 18 False NA
490 Chris Farley /Cast/?ChFa cast male 19 False NA
491 Chris Farley /Cast/?ChFa cast male 20 False NA
492 Robert Downey Jr. /Cast/?RoDJ cast male 11 False NA
493 Fred Wolf /Cast/?FrWo cast male 21 True NA
494 Fred Wolf /Cast/?FrWo cast male 22 True NA
495 Don Novello /Cast/?DoNo cast male 5 True 19791013
496 Don Novello /Cast/?DoNo cast male 11 True NA
497 Morwenna Banks /Cast/?MoBa cast female 20 False 19950408
498 Ellen Cleghorne /Cast/?ElCl cast female 17 True NA
499 Ellen Cleghorne /Cast/?ElCl cast female 18 True NA
500 Ellen Cleghorne /Cast/?ElCl cast female 19 False NA
501 Ellen Cleghorne /Cast/?ElCl cast female 20 False NA
502 Chris Elliott /Cast/?ChEl cast male 20 False NA
503 Jay Mohr /Cast/?JaMo cast male 19 True 19931009
504 Jay Mohr /Cast/?JaMo cast male 20 True NA
505 Laura Kightlinger /Cast/?LaKi cast female 20 True NA
506 Damon Wayans /Cast/?DaWa cast male 11 True NA
507 Janeane Garofalo /Cast/?JaGa cast female 20 False NA
508 Melanie Hutsell /Cast/?MeHu cast female 17 True 19911116
509 Melanie Hutsell /Cast/?MeHu cast female 18 True NA
510 Melanie Hutsell /Cast/?MeHu cast female 19 False NA
511 Julia Sweeney /Cast/?JuSw cast female 16 True 19901110
512 Julia Sweeney /Cast/?JuSw cast female 17 False NA
513 Julia Sweeney /Cast/?JuSw cast female 18 False NA
514 Julia Sweeney /Cast/?JuSw cast female 19 False NA
515 Jan Hooks /Cast/?JaHo cast female 12 False NA
516 Jan Hooks /Cast/?JaHo cast female 13 False NA
517 Jan Hooks /Cast/?JaHo cast female 14 False NA
518 Jan Hooks /Cast/?JaHo cast female 15 False NA
519 Jan Hooks /Cast/?JaHo cast female 16 False NA
520 Tom Schiller /Cast/?ToSc cast male 5 True 19800409
521 Siobhan Fallon /Cast/?SiFa cast female 17 True NA
522 Beth Cahill /Cast/?BeCa cast female 17 True 19911116
523 Victoria Jackson /Cast/?ViJa cast female 12 False NA
524 Victoria Jackson /Cast/?ViJa cast female 13 False NA
525 Victoria Jackson /Cast/?ViJa cast female 14 False NA
526 Victoria Jackson /Cast/?ViJa cast female 15 False NA
527 Victoria Jackson /Cast/?ViJa cast female 16 False NA
528 Victoria Jackson /Cast/?ViJa cast female 17 False NA
529 Dennis Miller /Cast/?DeMi cast male 11 False NA
530 Dennis Miller /Cast/?DeMi cast male 12 False NA
531 Dennis Miller /Cast/?DeMi cast male 13 False NA
532 Dennis Miller /Cast/?DeMi cast male 14 False NA
533 Dennis Miller /Cast/?DeMi cast male 15 False NA
534 Dennis Miller /Cast/?DeMi cast male 16 False NA
535 Randy Quaid /Cast/?RaQu cast male 11 False NA
536 A. Whitney Brown /Cast/?AWBr cast male 11 True 19860222
537 A. Whitney Brown /Cast/?AWBr cast male 12 True NA
538 A. Whitney Brown /Cast/?AWBr cast male 13 True NA
539 A. Whitney Brown /Cast/?AWBr cast male 14 True NA
540 A. Whitney Brown /Cast/?AWBr cast male 15 True NA
541 A. Whitney Brown /Cast/?AWBr cast male 16 True NA
542 Nora Dunn /Cast/?NoDu cast female 11 False NA
543 Nora Dunn /Cast/?NoDu cast female 12 False NA
544 Nora Dunn /Cast/?NoDu cast female 13 False NA
545 Nora Dunn /Cast/?NoDu cast female 14 False NA
546 Nora Dunn /Cast/?NoDu cast female 15 False NA
547 Laurie Metcalf /Cast/?LaMe cast female 6 True 19810411
548 Joan Cusack /Cast/?JoCu cast female 11 False NA
549 Terry Sweeney /Cast/?TeSw cast male 11 False NA
550 Danitra Vance /Cast/?DaVa cast female 11 False NA
551 Anthony Michael Hall /Cast/?AnMH cast male 11 False NA
552 Dan Vitale /Cast/?DaVi cast male 11 True NA
553 Christopher Guest /Cast/?ChGu cast male 10 False NA
554 Gary Kroeger /Cast/?GaKr cast male 8 False NA
555 Gary Kroeger /Cast/?GaKr cast male 9 False NA
556 Gary Kroeger /Cast/?GaKr cast male 10 False NA
557 Mary Gross /Cast/?MaGr cast female 7 False NA
558 Mary Gross /Cast/?MaGr cast female 8 False NA
559 Mary Gross /Cast/?MaGr cast female 9 False NA
560 Mary Gross /Cast/?MaGr cast female 10 False NA
561 Pamela Stephenson /Cast/?PaSt cast female 10 False NA
562 Rich Hall /Cast/?RiHa cast male 10 False NA
563 Harry Shearer /Cast/?HaSh cast male 5 False NA
564 Harry Shearer /Cast/?HaSh cast male 10 False NA
565 Alan Zweibel /Cast/?AlZw cast male 5 True 19800409
566 Yvonne Hudson /Cast/?YvHu cast female 6 True 19801220
567 Joe Piscopo /Cast/?JoPi cast male 6 False NA
568 Joe Piscopo /Cast/?JoPi cast male 7 False NA
569 Joe Piscopo /Cast/?JoPi cast male 8 False NA
570 Joe Piscopo /Cast/?JoPi cast male 9 False NA
571 Brad Hall /Cast/?BrHa cast male 8 False NA
572 Brad Hall /Cast/?BrHa cast male 9 False NA
573 Tim Kazurinsky /Cast/?TiKa cast male 6 False 19810411
574 Tim Kazurinsky /Cast/?TiKa cast male 7 False NA
575 Tim Kazurinsky /Cast/?TiKa cast male 8 False NA
576 Tim Kazurinsky /Cast/?TiKa cast male 9 False NA
577 Robin Duke /Cast/?RoDu cast female 6 False 19810411
578 Robin Duke /Cast/?RoDu cast female 7 False NA
579 Robin Duke /Cast/?RoDu cast female 8 False NA
580 Robin Duke /Cast/?RoDu cast female 9 False NA
581 Christine Ebersole /Cast/?ChEb cast female 7 False NA
582 Tony Rosato /Cast/?ToRo cast male 6 False 19810411
583 Tony Rosato /Cast/?ToRo cast male 7 False NA
584 Brian Doyle-Murray /Cast/?BrDM cast male 5 True 19800126
585 Brian Doyle-Murray /Cast/?BrDM cast male 7 True NA
586 Emily Prager /Cast/?EmPr cast female 6 True 19810411
587 John Belushi /Cast/?JoBe cast male 1 False NA
588 John Belushi /Cast/?JoBe cast male 2 False NA
589 John Belushi /Cast/?JoBe cast male 3 False NA
590 John Belushi /Cast/?JoBe cast male 4 False NA
591 Michael O'Donoghue /Cast/?MiOD cast male 1 False NA
592 Denny Dillon /Cast/?DeDi cast male 6 False NA
593 Gail Matthius /Cast/?GaMa cast female 6 False NA
594 Ann Risley /Cast/?AnRi cast female 6 False NA
595 Charles Rocket /Cast/?CaRo cast male 6 False NA
596 Matthew Laurance /Cast/?MaLa cast male 6 True 19801213
597 Patrick Weathers /Cast/?PaWe cast male 6 True 19801213
598 Peter Aykroyd /Cast/?PeAy cast male 5 True 19800126
599 Jane Curtin /Cast/?JaCu cast female 1 False NA
600 Jane Curtin /Cast/?JaCu cast female 2 False NA
601 Jane Curtin /Cast/?JaCu cast female 3 False NA
602 Jane Curtin /Cast/?JaCu cast female 4 False NA
603 Jane Curtin /Cast/?JaCu cast female 5 False NA
604 Laraine Newman /Cast/?LaNe cast female 1 False NA
605 Laraine Newman /Cast/?LaNe cast female 2 False NA
606 Laraine Newman /Cast/?LaNe cast female 3 False NA
607 Laraine Newman /Cast/?LaNe cast female 4 False NA
608 Laraine Newman /Cast/?LaNe cast female 5 False NA
609 Gilda Radner /Cast/?GiRa cast female 1 False NA
610 Gilda Radner /Cast/?GiRa cast female 2 False NA
611 Gilda Radner /Cast/?GiRa cast female 3 False NA
612 Gilda Radner /Cast/?GiRa cast female 4 False NA
613 Gilda Radner /Cast/?GiRa cast female 5 False NA
614 George Coe /Cast/?GeCo cast male 1 False NA
last_epid update_anchor n_episodes season_fraction
1 NA False 5 0.22727273
2 NA False 21 1.00000000
3 NA False 21 1.00000000
4 NA False 21 1.00000000
5 NA False 21 1.00000000
6 NA False 21 1.00000000
7 NA False 21 1.00000000
8 NA False 21 1.00000000
9 NA False 18 1.00000000
10 NA False 17 1.00000000
11 NA False 21 1.00000000
12 NA False 21 1.00000000
13 NA False 21 1.00000000
14 NA False 18 1.00000000
15 NA False 17 1.00000000
16 NA False 21 1.00000000
17 NA False 18 1.00000000
18 NA False 17 1.00000000
19 NA False 21 1.00000000
20 NA False 21 1.00000000
21 NA False 18 1.00000000
22 NA False 17 1.00000000
23 NA False 20 1.00000000
24 NA False 20 1.00000000
25 NA False 19 1.00000000
26 NA False 20 1.00000000
27 NA False 12 1.00000000
28 NA False 22 1.00000000
29 NA False 22 1.00000000
30 NA False 22 1.00000000
31 NA False 22 1.00000000
32 NA False 21 1.00000000
33 NA False 21 1.00000000
34 NA False 21 1.00000000
35 NA False 21 1.00000000
36 NA False 21 1.00000000
37 NA False 21 1.00000000
38 NA False 21 1.00000000
39 NA False 18 1.00000000
40 NA False 17 1.00000000
41 NA False 21 1.00000000
42 NA False 21 1.00000000
43 NA False 21 1.00000000
44 NA False 21 1.00000000
45 NA False 21 1.00000000
46 NA False 21 1.00000000
47 NA False 21 1.00000000
48 NA False 18 1.00000000
49 NA False 17 1.00000000
50 NA False 21 1.00000000
51 NA False 21 1.00000000
52 NA False 21 1.00000000
53 NA False 18 1.00000000
54 NA False 17 1.00000000
55 NA False 21 1.00000000
56 NA False 21 1.00000000
57 NA False 18 1.00000000
58 NA False 17 1.00000000
59 NA False 17 1.00000000
60 NA False 21 1.00000000
61 NA False 21 1.00000000
62 NA False 21 1.00000000
63 NA False 21 1.00000000
64 NA False 21 1.00000000
65 NA False 18 1.00000000
66 NA False 17 1.00000000
67 NA False 18 1.00000000
68 NA False 17 1.00000000
69 NA False 20 1.00000000
70 NA False 20 1.00000000
71 NA False 20 1.00000000
72 NA False 19 1.00000000
73 NA False 20 1.00000000
74 NA False 20 1.00000000
75 NA False 20 1.00000000
76 NA False 20 1.00000000
77 NA False 20 1.00000000
78 NA False 20 1.00000000
79 NA False 19 1.00000000
80 NA False 20 1.00000000
81 NA False 12 1.00000000
82 NA False 22 1.00000000
83 NA True 8 0.38095238
84 NA True 21 1.00000000
85 NA True 21 1.00000000
86 NA True 21 1.00000000
87 NA True 21 1.00000000
88 NA True 21 1.00000000
89 NA True 18 1.00000000
90 NA True 17 1.00000000
91 NA True 21 1.00000000
92 NA True 21 1.00000000
93 NA True 21 1.00000000
94 NA True 21 1.00000000
95 NA True 21 1.00000000
96 NA True 18 1.00000000
97 NA True 17 1.00000000
98 NA False 21 1.00000000
99 NA False 21 1.00000000
100 NA False 21 1.00000000
101 NA False 21 1.00000000
102 NA False 21 1.00000000
103 NA False 21 1.00000000
104 NA False 18 1.00000000
105 NA False 17 1.00000000
106 NA False 17 1.00000000
107 NA False 18 1.00000000
108 NA False 17 1.00000000
109 NA False 17 1.00000000
110 NA False 21 1.00000000
111 NA False 21 1.00000000
112 NA False 21 1.00000000
113 NA False 21 1.00000000
114 NA False 21 1.00000000
115 NA False 21 1.00000000
116 NA False 18 1.00000000
117 NA False 17 1.00000000
118 NA False 21 1.00000000
119 NA True 21 1.00000000
120 NA False 21 1.00000000
121 NA False 21 1.00000000
122 NA False 21 1.00000000
123 NA False 21 1.00000000
124 NA False 21 1.00000000
125 NA False 18 1.00000000
126 NA False 17 1.00000000
127 NA False 3 0.15000000
128 NA False 20 1.00000000
129 NA False 20 1.00000000
130 NA False 20 1.00000000
131 NA False 20 1.00000000
132 NA False 20 1.00000000
133 NA False 19 1.00000000
134 NA False 20 1.00000000
135 20071103 False 4 0.33333333
136 NA False 21 1.00000000
137 NA False 21 1.00000000
138 NA False 21 1.00000000
139 NA False 18 1.00000000
140 NA False 17 1.00000000
141 NA False 17 1.00000000
142 NA False 18 0.90000000
143 NA False 20 1.00000000
144 NA False 20 1.00000000
145 NA False 20 1.00000000
146 NA False 20 1.00000000
147 NA False 20 1.00000000
148 NA False 19 1.00000000
149 NA True 20 1.00000000
150 NA True 20 1.00000000
151 NA True 20 1.00000000
152 NA True 20 1.00000000
153 NA True 20 1.00000000
154 NA True 19 1.00000000
155 NA False 15 0.78947368
156 NA False 20 1.00000000
157 NA False 12 1.00000000
158 NA False 22 1.00000000
159 NA False 22 1.00000000
160 NA False 22 1.00000000
161 NA False 22 1.00000000
162 NA False 19 1.00000000
163 NA False 20 1.00000000
164 NA True 20 1.00000000
165 NA True 20 1.00000000
166 NA True 20 1.00000000
167 NA True 20 1.00000000
168 NA False 20 1.00000000
169 NA False 20 1.00000000
170 NA False 20 1.00000000
171 NA False 20 1.00000000
172 NA False 20 1.00000000
173 NA False 20 1.00000000
174 NA False 19 1.00000000
175 NA False 20 1.00000000
176 NA False 12 1.00000000
177 NA False 22 1.00000000
178 NA False 22 1.00000000
179 NA False 22 1.00000000
180 NA False 22 1.00000000
181 NA False 21 1.00000000
182 NA False 3 0.15000000
183 NA False 19 1.00000000
184 NA False 20 1.00000000
185 NA False 12 1.00000000
186 NA False 22 1.00000000
187 NA False 22 1.00000000
188 NA False 22 1.00000000
189 NA False 22 1.00000000
190 NA False 21 1.00000000
191 NA False 9 0.45000000
192 NA False 20 1.00000000
193 NA False 20 1.00000000
194 NA False 20 1.00000000
195 NA False 20 1.00000000
196 NA False 17 0.85000000
197 NA False 20 1.00000000
198 NA False 20 1.00000000
199 NA False 20 1.00000000
200 NA False 20 1.00000000
201 NA False 20 1.00000000
202 NA False 20 1.00000000
203 NA True 20 1.00000000
204 NA True 19 1.00000000
205 NA True 20 1.00000000
206 NA True 12 1.00000000
207 20081213 True 11 0.50000000
208 NA False 20 1.00000000
209 NA False 20 1.00000000
210 NA False 19 1.00000000
211 NA False 20 1.00000000
212 NA False 20 1.00000000
213 NA False 20 1.00000000
214 NA False 19 1.00000000
215 NA False 20 1.00000000
216 NA False 12 1.00000000
217 NA False 22 1.00000000
218 NA False 22 1.00000000
219 NA False 22 1.00000000
220 NA False 22 1.00000000
221 NA False 21 1.00000000
222 NA False 7 0.35000000
223 NA False 20 1.00000000
224 NA False 20 1.00000000
225 NA False 20 1.00000000
226 NA False 19 1.00000000
227 NA False 20 1.00000000
228 20010217 False 12 0.60000000
229 NA False 18 1.00000000
230 NA False 20 1.00000000
231 NA False 13 1.00000000
232 NA False 20 1.00000000
233 NA False 20 1.00000000
234 NA False 10 0.76923077
235 NA False 20 1.00000000
236 NA False 20 1.00000000
237 19840225 False 14 0.73684211
238 NA False 20 1.00000000
239 NA False 20 1.00000000
240 NA False 19 1.00000000
241 NA False 20 1.00000000
242 NA False 20 1.00000000
243 NA False 20 1.00000000
244 NA False 20 1.00000000
245 NA False 20 1.00000000
246 NA False 20 1.00000000
247 NA False 20 1.00000000
248 NA False 19 1.00000000
249 NA False 20 1.00000000
250 NA False 20 1.00000000
251 NA False 20 1.00000000
252 NA False 18 0.85714286
253 NA False 21 1.00000000
254 NA False 21 1.00000000
255 NA False 21 1.00000000
256 NA False 21 1.00000000
257 NA False 6 0.30000000
258 NA False 20 1.00000000
259 NA False 20 1.00000000
260 NA False 20 1.00000000
261 NA False 20 1.00000000
262 NA False 20 1.00000000
263 NA False 19 1.00000000
264 NA True 20 1.00000000
265 NA True 12 1.00000000
266 NA True 22 1.00000000
267 NA True 22 1.00000000
268 NA True 22 1.00000000
269 NA True 22 1.00000000
270 NA True 21 1.00000000
271 20140201 True 13 0.61904762
272 NA False 21 1.00000000
273 NA False 22 1.00000000
274 NA False 22 1.00000000
275 NA False 22 1.00000000
276 NA False 21 1.00000000
277 NA False 21 1.00000000
278 NA False 22 1.00000000
279 NA False 22 1.00000000
280 NA False 21 1.00000000
281 NA False 21 1.00000000
282 NA False 21 1.00000000
283 NA False 21 1.00000000
284 NA False 21 1.00000000
285 NA False 19 1.00000000
286 NA False 20 1.00000000
287 NA False 12 1.00000000
288 NA False 22 1.00000000
289 NA False 22 1.00000000
290 NA False 22 1.00000000
291 NA False 22 1.00000000
292 NA False 12 0.54545455
293 NA False 20 1.00000000
294 NA True 20 1.00000000
295 NA True 20 1.00000000
296 NA False 11 0.52380952
297 NA False 21 1.00000000
298 NA False 21 1.00000000
299 NA False 21 1.00000000
300 NA False 22 1.00000000
301 NA False 22 1.00000000
302 NA False 22 1.00000000
303 NA False 22 1.00000000
304 NA False 21 1.00000000
305 NA False 21 1.00000000
306 NA False 21 1.00000000
307 NA False 21 1.00000000
308 NA False 21 1.00000000
309 NA False 20 1.00000000
310 NA False 20 1.00000000
311 NA False 20 1.00000000
312 NA False 19 1.00000000
313 NA False 20 1.00000000
314 NA False 12 1.00000000
315 NA False 22 1.00000000
316 NA False 22 1.00000000
317 NA False 20 1.00000000
318 NA False 13 1.00000000
319 NA False 20 1.00000000
320 NA False 20 1.00000000
321 NA False 20 1.00000000
322 NA False 20 1.00000000
323 19930206 False 12 0.60000000
324 NA False 22 1.00000000
325 NA False 22 1.00000000
326 NA False 21 1.00000000
327 NA False 21 1.00000000
328 NA False 21 1.00000000
329 NA False 21 1.00000000
330 NA False 22 1.00000000
331 NA False 22 1.00000000
332 NA False 21 1.00000000
333 NA False 21 1.00000000
334 NA False 21 1.00000000
335 NA False 21 1.00000000
336 NA False 21 1.00000000
337 NA False 20 1.00000000
338 NA False 13 1.00000000
339 NA False 20 1.00000000
340 NA False 20 1.00000000
341 NA False 20 1.00000000
342 NA False 20 1.00000000
343 NA False 20 1.00000000
344 NA False 20 1.00000000
345 NA False 20 1.00000000
346 NA False 19 1.00000000
347 NA False 17 1.00000000
348 NA False 21 1.00000000
349 NA False 11 0.55000000
350 NA False 20 1.00000000
351 NA False 20 1.00000000
352 NA False 20 1.00000000
353 NA False 20 1.00000000
354 NA False 20 1.00000000
355 19950121 False 11 0.55000000
356 NA False 17 1.00000000
357 NA False 18 0.90000000
358 NA False 21 1.00000000
359 NA False 21 1.00000000
360 NA False 21 1.00000000
361 NA False 20 1.00000000
362 NA False 21 1.00000000
363 NA False 12 0.60000000
364 NA True 24 1.00000000
365 19761030 True 6 0.27272727
366 NA False 24 1.00000000
367 NA False 22 1.00000000
368 NA True 20 1.00000000
369 NA False 20 1.00000000
370 NA False 16 0.80000000
371 NA False 19 1.00000000
372 NA False 20 1.00000000
373 NA False 20 1.00000000
374 NA False 8 0.40000000
375 NA False 20 1.00000000
376 NA False 20 1.00000000
377 NA False 20 1.00000000
378 NA False 19 1.00000000
379 NA False 15 0.68181818
380 NA False 22 1.00000000
381 NA False 22 1.00000000
382 NA False 22 1.00000000
383 NA False 6 0.30000000
384 NA False 20 1.00000000
385 NA False 20 1.00000000
386 NA False 19 1.00000000
387 NA False 20 1.00000000
388 NA False 20 1.00000000
389 NA False 20 1.00000000
390 NA False 20 1.00000000
391 NA False 22 1.00000000
392 20120114 False 12 0.54545455
393 NA False 19 1.00000000
394 NA False 20 1.00000000
395 NA False 20 1.00000000
396 NA False 20 1.00000000
397 NA False 20 1.00000000
398 NA False 20 1.00000000
399 NA False 20 1.00000000
400 NA True 19 1.00000000
401 NA False 20 1.00000000
402 NA False 20 1.00000000
403 NA False 16 0.80000000
404 NA False 20 1.00000000
405 NA False 20 1.00000000
406 NA False 20 1.00000000
407 NA False 20 1.00000000
408 NA False 20 1.00000000
409 NA False 22 1.00000000
410 NA False 15 0.68181818
411 NA False 8 0.66666667
412 NA False 22 1.00000000
413 NA False 19 0.95000000
414 NA True 20 1.00000000
415 NA True 20 1.00000000
416 NA True 20 1.00000000
417 19980314 True 16 0.80000000
418 NA False 20 1.00000000
419 NA False 20 1.00000000
420 NA False 19 1.00000000
421 NA False 9 0.45000000
422 NA False 20 1.00000000
423 NA False 20 1.00000000
424 NA False 20 1.00000000
425 NA False 20 1.00000000
426 NA False 20 1.00000000
427 NA False 20 1.00000000
428 NA False 20 1.00000000
429 NA False 19 1.00000000
430 NA False 20 1.00000000
431 NA False 20 1.00000000
432 NA False 20 1.00000000
433 NA False 20 1.00000000
434 20040117 False 10 0.50000000
435 NA False 20 1.00000000
436 NA False 20 1.00000000
437 NA False 14 0.70000000
438 NA False 6 0.33333333
439 NA False 20 1.00000000
440 NA False 20 1.00000000
441 NA False 20 1.00000000
442 NA False 20 1.00000000
443 NA False 20 1.00000000
444 NA False 20 1.00000000
445 NA False 20 1.00000000
446 NA False 19 1.00000000
447 NA False 17 1.00000000
448 NA False 20 1.00000000
449 NA False 20 1.00000000
450 NA False 16 0.80000000
451 NA False 20 1.00000000
452 NA False 20 1.00000000
453 NA False 24 1.00000000
454 NA False 22 1.00000000
455 NA False 20 1.00000000
456 NA False 20 1.00000000
457 NA False 20 1.00000000
458 NA False 20 1.00000000
459 NA False 20 1.00000000
460 NA True 20 1.00000000
461 NA True 19 1.00000000
462 NA True 20 1.00000000
463 NA False 20 1.00000000
464 NA False 13 1.00000000
465 NA False 20 1.00000000
466 NA False 20 1.00000000
467 NA False 20 1.00000000
468 NA True 20 1.00000000
469 NA True 20 1.00000000
470 NA True 20 1.00000000
471 NA False 20 1.00000000
472 NA False 20 1.00000000
473 NA False 20 1.00000000
474 NA False 20 1.00000000
475 NA False 20 1.00000000
476 NA False 19 1.00000000
477 NA False 20 1.00000000
478 NA False 20 1.00000000
479 NA False 20 1.00000000
480 NA False 20 1.00000000
481 NA False 13 1.00000000
482 NA False 11 0.55000000
483 NA False 20 1.00000000
484 NA False 20 1.00000000
485 NA False 6 0.30000000
486 NA False 20 1.00000000
487 NA False 20 1.00000000
488 NA False 20 1.00000000
489 NA False 20 1.00000000
490 NA False 20 1.00000000
491 NA False 20 1.00000000
492 NA False 18 1.00000000
493 NA False 20 1.00000000
494 19961019 False 3 0.15000000
495 NA False 20 1.00000000
496 NA False 18 1.00000000
497 NA False 4 0.20000000
498 NA False 20 1.00000000
499 NA False 20 1.00000000
500 NA False 20 1.00000000
501 NA False 20 1.00000000
502 NA False 20 1.00000000
503 NA False 18 0.90000000
504 NA False 20 1.00000000
505 NA False 20 1.00000000
506 19860315 False 12 0.66666667
507 19950225 False 14 0.70000000
508 NA False 15 0.75000000
509 NA False 20 1.00000000
510 NA False 20 1.00000000
511 NA False 16 0.80000000
512 NA False 20 1.00000000
513 NA False 20 1.00000000
514 NA False 20 1.00000000
515 NA False 20 1.00000000
516 NA False 13 1.00000000
517 NA False 20 1.00000000
518 NA False 20 1.00000000
519 NA False 20 1.00000000
520 NA False 5 0.25000000
521 NA False 20 1.00000000
522 NA False 15 0.75000000
523 NA False 20 1.00000000
524 NA False 13 1.00000000
525 NA False 20 1.00000000
526 NA False 20 1.00000000
527 NA False 20 1.00000000
528 NA False 20 1.00000000
529 NA True 18 1.00000000
530 NA True 20 1.00000000
531 NA True 13 1.00000000
532 NA True 20 1.00000000
533 NA True 20 1.00000000
534 NA True 20 1.00000000
535 NA False 18 1.00000000
536 NA False 8 0.44444444
537 NA False 20 1.00000000
538 NA False 13 1.00000000
539 NA False 20 1.00000000
540 NA False 20 1.00000000
541 NA False 20 1.00000000
542 NA False 18 1.00000000
543 NA False 20 1.00000000
544 NA False 13 1.00000000
545 NA False 20 1.00000000
546 NA False 20 1.00000000
547 NA False 1 0.07692308
548 NA False 18 1.00000000
549 NA False 18 1.00000000
550 NA False 18 1.00000000
551 NA False 18 1.00000000
552 NA False 18 1.00000000
553 NA True 17 1.00000000
554 NA False 20 1.00000000
555 NA False 19 1.00000000
556 NA False 17 1.00000000
557 NA True 20 1.00000000
558 NA False 20 1.00000000
559 NA False 19 1.00000000
560 NA False 17 1.00000000
561 NA False 17 1.00000000
562 NA False 17 1.00000000
563 NA False 20 1.00000000
564 19850112 False 10 0.58823529
565 NA False 5 0.25000000
566 NA False 9 0.69230769
567 NA False 13 1.00000000
568 NA False 20 1.00000000
569 NA False 20 1.00000000
570 NA False 19 1.00000000
571 NA True 20 1.00000000
572 NA True 19 1.00000000
573 NA False 1 0.07692308
574 NA False 20 1.00000000
575 NA False 20 1.00000000
576 NA False 19 1.00000000
577 NA False 1 0.07692308
578 NA False 20 1.00000000
579 NA False 20 1.00000000
580 NA False 19 1.00000000
581 NA True 20 1.00000000
582 NA False 1 0.07692308
583 NA False 20 1.00000000
584 NA False 12 0.60000000
585 NA True 20 1.00000000
586 NA False 1 0.07692308
587 NA False 24 1.00000000
588 NA False 22 1.00000000
589 NA False 20 1.00000000
590 NA False 20 1.00000000
591 19751108 False 4 0.16666667
592 NA False 13 1.00000000
593 NA True 13 1.00000000
594 NA False 13 1.00000000
595 NA True 13 1.00000000
596 NA False 10 0.76923077
597 NA False 10 0.76923077
598 NA False 12 0.60000000
599 NA False 24 1.00000000
600 NA True 22 1.00000000
601 NA True 20 1.00000000
602 NA True 20 1.00000000
603 NA True 20 1.00000000
604 NA False 24 1.00000000
605 NA False 22 1.00000000
606 NA False 20 1.00000000
607 NA False 20 1.00000000
608 NA False 20 1.00000000
609 NA False 24 1.00000000
610 NA False 22 1.00000000
611 NA False 20 1.00000000
612 NA False 20 1.00000000
613 NA False 20 1.00000000
614 19751011 False 1 0.04166667ggplot(dfjoin, aes(gender)) +
geom_bar(aes(fill = featured))